<head>
	
	<!-- 
		=================================================================================================
		Copyright (c) 2012 Athena Health. 
		This software is the proprietary information of Athena Health
		All Right Reserved.
		Repository path:    $HeadURL: http://athena-call-routing.googlecode.com/svn/trunk/kickcodes.php $
		Last committed:     $Revision: 45 $
		Last changed by:    $Author: davidjmorin@gmail.com $
		Last changed date:    $Date: 2012-07-02 21:10:12 -0400 (Mon, 02 Jul 2012) $
		ID:            $Id: index.php 45 2012-07-03 01:10:12Z davidjmorin@gmail.com $
		=================================================================================================
	-->
	<style type="text/css">
		body {background-color:#42520e;}
		th {background: URL(http://www.athenahealth.com/_img/boxes/carousel_bg.png);}
		p {color:blue;}
	</style>
</head>
<a href="index.php">Back to Resource Page</a>
<?php
	
	define("HOST", "localhost");
	
	// Database user
	define("DBUSER", "root");
	
	// Database password
	define("PASS", "123456");
	
	// Database name
	define("DB", "bbpinpal_article");
	
	############## Make the mysql connection ###########
	
	$conn = mysql_connect(HOST, DBUSER, PASS) or  die('Could not connect !<br />Please contact the site\'s administrator.');
	
	$db = mysql_select_db(DB) or  die('Could not connect to database !<br />Please contact the site\'s administrator.');
	$id = $_GET['id']; 
	
	//$query = mysql_query(" SELECT * FROM athena WHERE keyword='".$_POST['value']."' ");
	$query = mysql_query("SELECT * FROM kickcodes WHERE blockID='{$id}'");
?>
<br />Searching for topics related to <b><?php echo "$id"; ?></b>
<?php
	echo "<table border='.5' color='#fff'>
	<tr>
	<th bgcolor='#42520e' style='font-size:18px; color:#fff;'>Keyword</th>
	<th bgcolor='#42520e'style='font-size:18px; color:#fff;'>block</th>
	<th bgcolor='#42520e'style='font-size:18px; color:#fff;'>Phone #</th>
	<th bgcolor='#42520e'style='font-size:18px; color:#fff;'>Reason</th>
	
	</tr>";
	
	while ($data = mysql_fetch_array($query)) {
		
		echo '
		<tr style="background-color:#576c11;">
		<td style="font-size:18px; color:#f0cb01;">'.$data["kickcode"].'</td>
		<td style="font-size:18px;color:#f0cb01;">'.$data["blockID"].'</td>
		<td style="font-size:18px;color:#f0cb01;">'.$data["desc"].'</td>
	<td style="font-size:18px;color:#f0cb01;">'.$data["next_status"].'</td>
	<td style="font-size:18px;color:#f0cb01;">'.$data["next_steps"].'</td>
	
	
	
	
	</tr>';
	
	}
	
	echo '</table>';
	
	?>
	
		